﻿CREATE PROCEDURE [dbo].[proc_Employee_ZhiWu_GetList]

AS
	Select 
	     Id,
		 Title,
		 Pid,
		 UpTime,
		 isnull((select Title from Employee_ZhiWu where Id=ez1.Pid ),'未知') as TypeTitle
	From Employee_ZhiWu ez1 where Pid<>0


	--SELECT  Id,Pid,case when Pid<>0 then replicate('┆┄┄',1)+isnull(Title,'') else '◆'+isnull(Title,'') end as Title from Employee_ZhiWu

	RETURN

